﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Manager;
using Model;
using System.Data;
namespace HealthSystem
{
    public partial class Resultinfo : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindGrid();
            }
        }
        public void BindGrid()
        {
            string tjnd = Request["tjnd"] as string;
            string studentid = Request["studentid"] as string;
            tjndfiled.Value = tjnd;
            bhfiled.Value = studentid;
            ResultManager manager = new ResultManager();
            HW_Result2013 result=manager.GetModelStudent(tjnd, studentid);
            if (result == null)
            {
                ExtAspNet.Alert.Show("不存在体检记录");
                return;
            }
            //字典翻译
            result = manager.Translate(result);
            //沙眼与视力翻译
            result = manager.GetResult(result);
            this.litXh.Text = result.XH;
            this.litXm.Text =result.XM;
            this.litSex.Text =result.XB;

            //this.litMz.Text =result.MZ;


            //str3 = reader2["schoolbh"] as string;
            this.litCsrq.Text = result.CSRQ.ToShortDateString();

            //this.litSchoolname.Text = result.SCHOOL_NAME;

            this.litClassname.Text = result.CLASS_NAME;

            //this.litRxsj.Text = result.RXSJ;

            //if (!Convert.IsDBNull(reader2["Sg"]))
            //{
            this.litSg.Text =result.SG.HasValue?Math.Round(result.SG.Value,1).ToString() + "cm":"";
            //}
            //if (!Convert.IsDBNull(reader2["Tz"]))
            //{
            this.litTz.Text = result.TZ.HasValue ? Math.Round(result.TZ.Value,1).ToString() + "kg" : "";
            //}
            //if (!Convert.IsDBNull(reader2["Xw"]))
            //{
            this.litXw.Text = result.XW.HasValue ? Math.Round(result.XW.Value,1).ToString() + "cm" : "";
            //}
            //if (!Convert.IsDBNull(reader2["Fhl"]))
            //{
            this.litFhl.Text = result.FHL.HasValue ? Math.Round(result.FHL.Value,1).ToString() + " ml" : "";
            //}
            //if (!Convert.IsDBNull(reader2["Yw"]))
            //{
            this.litYw.Text = result.YW.HasValue ? Math.Round(result.YW.Value,1).ToString() + "cm" : "";
            //}
            //if (!Convert.IsDBNull(reader2["Tw"]))
            //{
            this.litTw.Text = result.TW.HasValue ? Math.Round(result.TW.Value,1).ToString() + "cm" : "";
            //}
            //if (!Convert.IsDBNull(reader2["Ssy"]) && !Convert.IsDBNull(reader2["Szy"]))
            //{
                this.litXy.Text = result.SSY.HasValue?Math.Round(result.SSY.Value,1).ToString():""+ "/" + result.SZY as string;
            //}
            //if (!Convert.IsDBNull(reader2["lsl"]) && !Convert.IsDBNull(reader2["rsl"]))
            //{
                //this.litSl.Text = "左 " + Convert.ToDouble(reader2["lsl"]).ToString("N1") + " / 右 " + Convert.ToDouble(reader2["rsl"]).ToString("N1");
                string lsl = result.LSL.HasValue ? Math.Round(result.LSL.Value, 1).ToString() : "";
                string rsl = result.RSL.HasValue ? Math.Round(result.RSL.Value, 1).ToString() : "";
                this.litSl.Text = "左 " + lsl + " / 右 " + rsl;
            //}
            //this.litQg.Text = "左 " + reader2["lqg"] as string + " / 右 " + reader2["rqg"] as string;
                this.litQg.Text = "左 " + result.LQG + " / 右 " + result.RQG as string;
                this.litRs.Text = result.RS as string;
                this.litSj.Text = result.BS as string;
                this.litSy.Text = result.SSYPJ as string;
                this.litJmy.Text = result.JMY as string;
            //this.litQc.Text = reader2["Qcpj"] as string;
                this.litQc.Text = result.QCQFY.HasValue?result.QCQFY.Value.ToString():"";
                this.litYzb.Text = result.YZB as string;
                this.litTl.Text = "左 " + result.TL + " / 右 " + result.RTL as string;
                this.litEb.Text = result.EB as string;
                this.litBb.Text = result.BB as string;
                this.litTb.Text = result.TB as string;
                this.litJb.Text = result.JB as string;
                this.litBtt.Text = result.BTT as string;

                //this.litXk.Text = result.XK as string;

                this.litJz.Text = result.JZ as string;
                this.litSz.Text = result.SZ as string;
                this.litPf.Text = result.PF as string;
                this.litLbj.Text = result.LBJ as string;

                //this.litWszq.Text = result.WSZQ as string;

                this.litXz.Text = result.XZ as string;
                this.litFei.Text = result.FEI as string;
                this.litGan.Text = result.GP as string;
                this.litPei.Text = result.PEI as string;
            //if (!Convert.IsDBNull(reader2["Mb"]))
            //{
                this.litMb.Text = result.MB.HasValue ? Math.Round(result.MB.Value,1).ToString() + "  次/分钟" : "";
            //}
            //if (!Convert.IsDBNull(reader2["Xhdb"]))
            //{
                //this.litXhdb.Text = "血红蛋白：" + result.XHDB as string + "  g/L";
            //}
                this.litGg.Text = result.GG as string;
                this.litJhjs.Text = result.JHJS as string;
                this.litHcl.Text = result.FHCL as string;
                //this.litXx.Text = result.BLOOD.ToString();
              //if (result.XB == "男")
              //{
              //    this.litQcq.Text = "男生：若出现遗精，首次遗精年龄 " + result.QCQFY + " 岁";
              //}
              //else
              //{
              //    this.litQcq.Text = "女生：若出现月经，初潮年龄 " + result.QCQFY + " 岁";
              //}

                litSgpj.Text = result.SGDJD;
                litTzpj.Text = result.TZDJD;
                litAge.Text = (result.NL.HasValue ? result.NL.Value.ToString() : "未知");
                litFypj.Text = result.FYPJ;
                litPz.Text = result.PZ;
                litJzx.Text = result.JZX;
                litGbzam.Text = result.GBZAM.HasValue?Math.Round(result.GBZAM.Value,2).ToString():"";//谷丙转氨酶
                litPx.Text = result.PXPJ;
                litBmkt.Text = result.BMKT;
                litXwpj.Text = result.XWDJD;
                litFhlpj.Text = result.FHLDJD;
                litYypj.Text = result.YYPJ;
                litDhs.Text = result.DHSA.HasValue ? Math.Round(result.DHSA.Value).ToString() : "";
                litBmky.Text = result.BMKY;
                litHcl.Text = result.FHCL;

                Liteyma.Text = result.YMA;
                Liteymb.Text = result.YMB;
                Liteymc.Text = result.YMC;
                Liteymd.Text = result.YMD;
                Liteyme.Text = result.YME;
        }
        //public void BindSelfItem()
        //{
        //    string tjnd = Request["tjnd"] as string;
        //    string studentid = Request["studentid"] as string;
        //    ResultManager manager = new ResultManager();
        //    var selfresult = manager.GetSelfResult(tjnd, studentid);
        //    if (selfresult.Rows.Count > 0)
        //    {
        //        List<SelfItem> list = new List<SelfItem>();
        //        SelfItem item = null;
        //        Dictionary<string, string> result = new Dictionary<string, string>();
        //        for (int i = 0; i < 20; i++)
        //        {
        //            if (i % 2 == 0)
        //            {
        //                if (!(selfresult.Rows[0][i] is DBNull))
        //                {
        //                    item.Name = selfresult.Rows[0][i] as string;
        //                    item.Value = selfresult.Rows[0][i + 1] as string;
        //                    list.Add(item);
        //                }
        //            }
        //        }
        //    }
        //}
        //protected void Page_Load(object sender, EventArgs e)
        //{
        //    if (!base.IsPostBack && !string.IsNullOrEmpty(base.Request.QueryString["checkId"].ToString()))
        //    {
        //        string cmdText = "";
        //        cmdText = "delete from tjpjgt where checkId=" + base.Request.QueryString["checkId"].ToString();
        //        SqlHelper.ExecuteScalar(SqlHelper.ConnHealth, CommandType.Text, cmdText, new SqlParameter[0]);
        //        StringBuilder builder = new StringBuilder(0x2800);
        //        builder.Append(" insert into tjpjgt(checkId,tjnd,bh,schoolbh,gradebh,classbh,rxsj,xh,school_name,grade_name,class_name,xm,xb,mz,csrq,tjrq,nl,sy,mark,sg,sgpj,tz,tzpj,yypjx,txpj,fypj,xw,xwpj,fhl,fhlpj,ssy,ssypj,szy,szypj,mb,mbpj,wsm,wsmpj,ldty,ldtypj,ll,llpj,nnl,nnlpj,");
        //        builder.Append(" wl,wlpj,zwt,zwtpj,zg,jk,gpk,bjl,gstj,jjx,lsl,rsl,qtyb,lsy,rsy,bs,tl,xj,bb,qsb,yzb,btt,xk,jz,sz,pz,xz,gp,fei,xt,xhdb,pxpj,fhcl,pfb,bmky,sjsr,tjsy,tjpj,hxp,hxppj,eb,yb,tb,jb,pf,jzx,lbj,jhjs,gbzam,dhsa,dhsz,gg,bmkt,");
        //        builder.Append(" yghkt,ygeky,ygekt,blood,cxbh,yw,tw,ljsl,rjsl,jmy,wgfb,yyb,pei,rtl,wszq,Lqg,Rqg,Rs,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10)");
        //        builder.Append(" select checkId,tjnd,bh,schoolbh,gradebh,classbh,rxsj,xh,school_name,grade_name,class_name,xm,xb,mz,csrq,tjrq,nl,sy,mark,sg,sgdjd,tz,tzdjd,yypjx,txpj,fypj,xw,xwdjd,fhl,fhldjd,ssy,ssypj,szy,szypj,mb,mbpj,wsm,wsmdjd,ldty,ldtydjd,ll,lldjd,nnl,nnldjd,");
        //        builder.Append(" wl,wldjd,zwt,zwtdjd,zg,jk,gpk,bjl,gstj,jjx,lsl,rsl,qtyb,lsy,rsy,bs,tl,xj,bb,qsbnum,yzb,btt,xk,jz,sz,pz,xz,gp,fei,xt,xhdb,pxpj,fhcl,pfb,bmky,sjsr,tjsy,tjpj,hxp,hxppj,eb,yb,tb,jb,pf,jzx,lbj,jhjs,gbzam,dhsa,dhsz,gg,bmkt,");
        //        builder.Append(" yghkt,ygeky,ygekt,blood,cxbh,yw,tw,ljsl,rjsl,jmy,wgfb,yyb,pei,rtl,wszq,Lqg,Rqg,Rs,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10");
        //        builder.Append(" from checkdb where checkid=" + base.Request.QueryString["checkId"].ToString());
        //        cmdText = builder.ToString();
        //        SqlHelper.ExecuteScalar(SqlHelper.ConnHealth, CommandType.Text, cmdText, new SqlParameter[0]);
        //        this.bindData();
        //    }


        //}
        //private void bindData()
        //{
        //    string str;
        //    string str2;
        //    string str3 = "";
        //    for (int i = 14; i <= 0x5d; i++)
        //    {
        //        switch (i)
        //        {
        //            case 0x11:
        //            case 0x12:
        //                break;

        //            default:
        //                str = "select xmbh,Itemcode,itemresult,fieldmc from itemresult where xmbh ='" + i.ToString() + "'";
        //                using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnHealth, CommandType.Text, str, new SqlParameter[0]))
        //                {
        //                    try
        //                    {
        //                        while (reader.Read())
        //                        {
        //                            str2 = "update tjpjgt set " + reader["fieldmc"].ToString() + "='" + reader["itemresult"].ToString() + "' where " + reader["fieldmc"].ToString() + "='" + reader["itemcode"].ToString() + "'";
        //                            SqlHelper.ExecuteNonQuery(SqlHelper.ConnHealth, CommandType.Text, str2, new SqlParameter[0]);
        //                        }
        //                    }
        //                    finally
        //                    {
        //                        reader.Close();
        //                    }
        //                }
        //                break;
        //        }
        //        if (i == 0x11)
        //        {
        //            str2 = "update tjpjgt set sypj='无' where lsy='0' and rsy='0'";
        //            SqlHelper.ExecuteNonQuery(SqlHelper.ConnHealth, CommandType.Text, str2, new SqlParameter[0]);
        //            str2 = "update tjpjgt set sypj='可疑' where ((lsy='1') or (rsy='1')) and (lsy<>'2') and (rsy<>'2')";
        //            SqlHelper.ExecuteNonQuery(SqlHelper.ConnHealth, CommandType.Text, str2, new SqlParameter[0]);
        //            str2 = "update tjpjgt set sypj='有沙' where ((lsy='2') or (rsy='2'))";
        //            SqlHelper.ExecuteNonQuery(SqlHelper.ConnHealth, CommandType.Text, str2, new SqlParameter[0]);
        //        }
        //    }
        //    str2 = "update tjpjgt set slpj='视力低下' where (lsl<5.0) or (rsl<5.0)";
        //    SqlHelper.ExecuteNonQuery(SqlHelper.ConnHealth, CommandType.Text, str2, new SqlParameter[0]);
        //    str2 = "update tjpjgt set slpj='正常' where (lsl>=5.0) and (rsl>=5.0)";
        //    SqlHelper.ExecuteNonQuery(SqlHelper.ConnHealth, CommandType.Text, str2, new SqlParameter[0]);
        //    str2 = "update tjpjgt set qcpj='无龋齿'  where qsb=0";
        //    SqlHelper.ExecuteNonQuery(SqlHelper.ConnHealth, CommandType.Text, str2, new SqlParameter[0]);
        //    str2 = "update tjpjgt set qcpj='有龋齿'  where qsb>0";
        //    SqlHelper.ExecuteNonQuery(SqlHelper.ConnHealth, CommandType.Text, str2, new SqlParameter[0]);
        //    str = "SELECT * From Tjpjgt";
        //    using (SqlDataReader reader2 = SqlHelper.ExecuteReader(SqlHelper.ConnHealth, CommandType.Text, str, new SqlParameter[0]))
        //    {
        //        try
        //        {
        //            while (reader2.Read())
        //            {
        //                this.litXh.Text = reader2["Xh"].ToString();
        //                this.litXm.Text = reader2["xm"].ToString();
        //                this.litSex.Text = reader2["xb"].ToString();
        //                this.litMz.Text = reader2["mz"].ToString();
        //                str3 = reader2["schoolbh"].ToString();
        //                this.litCsrq.Text = Convert.ToDateTime(reader2["Csrq"]).ToShortDateString();
        //                this.litSchoolname.Text = reader2["School_name"].ToString();
        //                this.litClassname.Text = reader2["Class_name"].ToString();
        //                this.litRxsj.Text = reader2["Rxsj"].ToString();
        //                if (!Convert.IsDBNull(reader2["Sg"]))
        //                {
        //                    this.litSg.Text = Convert.ToDouble(reader2["Sg"]).ToString("N1") + "cm";
        //                }
        //                if (!Convert.IsDBNull(reader2["Tz"]))
        //                {
        //                    this.litTz.Text = Convert.ToDouble(reader2["Tz"]).ToString("N1") + "kg";
        //                }
        //                if (!Convert.IsDBNull(reader2["Xw"]))
        //                {
        //                    this.litXw.Text = Convert.ToDouble(reader2["Xw"]).ToString("N1") + "cm";
        //                }
        //                if (!Convert.IsDBNull(reader2["Fhl"]))
        //                {
        //                    this.litFhl.Text = Convert.ToDouble(reader2["Fhl"]).ToString() + " ml";
        //                }
        //                if (!Convert.IsDBNull(reader2["Yw"]))
        //                {
        //                    this.litYw.Text = Convert.ToDouble(reader2["Yw"]).ToString("N1") + "cm";
        //                }
        //                if (!Convert.IsDBNull(reader2["Tw"]))
        //                {
        //                    this.litTw.Text = Convert.ToDouble(reader2["Tw"]).ToString("N1") + "cm";
        //                }
        //                if (!Convert.IsDBNull(reader2["Ssy"]) && !Convert.IsDBNull(reader2["Szy"]))
        //                {
        //                    this.litXy.Text = Convert.ToDouble(reader2["Ssy"]).ToString("N1") + " / " + Convert.ToDouble(reader2["Szy"]).ToString("N1");
        //                }
        //                if (!Convert.IsDBNull(reader2["lsl"]) && !Convert.IsDBNull(reader2["rsl"]))
        //                {
        //                    this.litSl.Text = "左 " + Convert.ToDouble(reader2["lsl"]).ToString("N1") + " / 右 " + Convert.ToDouble(reader2["rsl"]).ToString("N1");
        //                }
        //                this.litQg.Text = "左 " + reader2["lqg"].ToString() + " / 右 " + reader2["rqg"].ToString();
        //                this.litRs.Text = reader2["Rs"].ToString();
        //                this.litSj.Text = reader2["Bs"].ToString();
        //                this.litSy.Text = reader2["Sypj"].ToString();
        //                this.litJmy.Text = reader2["Jmy"].ToString();
        //                this.litQc.Text = reader2["Qcpj"].ToString();
        //                this.litYzb.Text = reader2["Yzb"].ToString();
        //                this.litTl.Text = "左 " + reader2["Tl"].ToString() + " / 右 " + reader2["Rtl"].ToString();
        //                this.litEb.Text = reader2["Eb"].ToString();
        //                this.litBb.Text = reader2["Bb"].ToString();
        //                this.litTb.Text = reader2["Tb"].ToString();
        //                this.litJb.Text = reader2["Jb"].ToString();
        //                this.litBtt.Text = reader2["Btt"].ToString();
        //                this.litXk.Text = reader2["Xk"].ToString();
        //                this.litJz.Text = reader2["Jz"].ToString();
        //                this.litSz.Text = reader2["Sz"].ToString();
        //                this.litPf.Text = reader2["Pf"].ToString();
        //                this.litLbj.Text = reader2["Lbj"].ToString();
        //                this.litWszq.Text = reader2["Wszq"].ToString();
        //                this.litXz.Text = reader2["Xz"].ToString();
        //                this.litFei.Text = reader2["Fei"].ToString();
        //                this.litGan.Text = reader2["Gp"].ToString();
        //                this.litPei.Text = reader2["Pei"].ToString();
        //                if (!Convert.IsDBNull(reader2["Mb"]))
        //                {
        //                    this.litMb.Text = Convert.ToDouble(reader2["Mb"]).ToString() + "  次/分钟";
        //                }
        //                if (!Convert.IsDBNull(reader2["Xhdb"]))
        //                {
        //                    this.litXhdb.Text = "血红蛋白：" + Convert.ToDouble(reader2["Xhdb"]).ToString() + "  g/L";
        //                }
        //                this.litGg.Text = reader2["Gg"].ToString();
        //                this.litJhjs.Text = reader2["Jhjs"].ToString();
        //                this.litHcl.Text = reader2["Fhcl"].ToString();
        //                this.litXx.Text = reader2["Blood"].ToString();
        //            }
        //        }
        //        finally
        //        {
        //            reader2.Close();
        //        }
        //    }
        //    str = "delete from tjpjgt where checkId=" + base.Request.QueryString["checkId"].ToString();
        //    SqlHelper.ExecuteScalar(SqlHelper.ConnHealth, CommandType.Text, str, new SqlParameter[0]);
        //    str = "select RXYFJZS from checkdb where checkid=" + base.Request.QueryString["checkId"].ToString();
        //    using (SqlDataReader reader3 = SqlHelper.ExecuteReader(SqlHelper.ConnHealth, CommandType.Text, str, new SqlParameter[0]))
        //    {
        //        try
        //        {
        //            while (reader3.Read())
        //            {
        //                this.litJzrxq.Text = reader3["RXYFJZS"].ToString();
        //            }
        //        }
        //        finally
        //        {
        //            reader3.Close();
        //        }
        //    }
        //    str = "select RXHJZS from checkdb where checkid=" + base.Request.QueryString["checkId"].ToString();
        //    using (SqlDataReader reader4 = SqlHelper.ExecuteReader(SqlHelper.ConnHealth, CommandType.Text, str, new SqlParameter[0]))
        //    {
        //        try
        //        {
        //            while (reader4.Read())
        //            {
        //                this.litJzrxh.Text = reader4["RXHJZS"].ToString();
        //            }
        //        }
        //        finally
        //        {
        //            reader4.Close();
        //        }
        //    }
        //    str = "select Jwbs from checkdb where checkid=" + base.Request.QueryString["checkId"] as string;
        //    using (SqlDataReader reader5 = SqlHelper.ExecuteReader(SqlHelper.ConnHealth, CommandType.Text, str, new SqlParameter[0]))
        //    {
        //        try
        //        {
        //            while (reader5.Read())
        //            {
        //                this.litJwbs.Text = reader5["Jwbs"].ToString();
        //            }
        //        }
        //        finally
        //        {
        //            reader5.Close();
        //        }
        //    }
        //    str = "select xb,qcqfy from checkdb where checkid=" + base.Request.QueryString["checkId"].ToString();
        //    using (SqlDataReader reader6 = SqlHelper.ExecuteReader(SqlHelper.ConnHealth, CommandType.Text, str, new SqlParameter[0]))
        //    {
        //        try
        //        {
        //            while (reader6.Read())
        //            {
        //                if (reader6["xb"].ToString() == "男")
        //                {
        //                    this.litQcq.Text = "男生：若出现遗精，首次遗精年龄 " + reader6["qcqfy"].ToString() + " 岁";
        //                }
        //                else
        //                {
        //                    this.litQcq.Text = "女生：若出现月经，初潮年龄 " + reader6["qcqfy"].ToString() + " 岁";
        //                }
        //            }
        //        }
        //        finally
        //        {
        //            reader6.Close();
        //        }
        //    }
        //    string str4 = "";
        //    str = "select yma from checkdb where checkid=" + base.Request.QueryString["checkId"].ToString() + " and  yma is not null";
        //    using (SqlDataReader reader7 = SqlHelper.ExecuteReader(SqlHelper.ConnHealth, CommandType.Text, str, new SqlParameter[0]))
        //    {
        //        try
        //        {
        //            while (reader7.Read())
        //            {
        //                str4 = str4 + "卡介苗：" + reader7["yma"].ToString() + "；";
        //            }
        //        }
        //        finally
        //        {
        //            reader7.Close();
        //        }
        //    }
        //    str = "select ymb from checkdb where checkid=" + base.Request.QueryString["checkId"].ToString() + " and ymb is not null";
        //    using (SqlDataReader reader8 = SqlHelper.ExecuteReader(SqlHelper.ConnHealth, CommandType.Text, str, new SqlParameter[0]))
        //    {
        //        try
        //        {
        //            while (reader8.Read())
        //            {
        //                str4 = str4 + "乙型肝炎疫苗：" + reader8["ymb"].ToString() + "；";
        //            }
        //        }
        //        finally
        //        {
        //            reader8.Close();
        //        }
        //    }
        //    str = "select ymc from checkdb where checkid=" + base.Request.QueryString["checkId"].ToString() + " and ymc is not null";
        //    using (SqlDataReader reader9 = SqlHelper.ExecuteReader(SqlHelper.ConnHealth, CommandType.Text, str, new SqlParameter[0]))
        //    {
        //        try
        //        {
        //            while (reader9.Read())
        //            {
        //                str4 = str4 + "麻疹疫苗：" + reader9["ymc"].ToString() + "；";
        //            }
        //        }
        //        finally
        //        {
        //            reader9.Close();
        //        }
        //    }
        //    str = "select ymd from checkdb where checkid=" + base.Request.QueryString["checkId"].ToString() + " and ymd is not null";
        //    using (SqlDataReader reader10 = SqlHelper.ExecuteReader(SqlHelper.ConnHealth, CommandType.Text, str, new SqlParameter[0]))
        //    {
        //        try
        //        {
        //            while (reader10.Read())
        //            {
        //                str4 = str4 + "脊髓灰质炎疫苗：" + reader10["ymd"].ToString() + "；";
        //            }
        //        }
        //        finally
        //        {
        //            reader10.Close();
        //        }
        //    }
        //    str = "select yme from checkdb where checkid=" + base.Request.QueryString["checkId"] as string + " and yme is not null";
        //    using (SqlDataReader reader11 = SqlHelper.ExecuteReader(SqlHelper.ConnHealth, CommandType.Text, str, new SqlParameter[0]))
        //    {
        //        try
        //        {
        //            while (reader11.Read())
        //            {
        //                str4 = str4 + "百白破疫苗：" + reader11["yme"] as string + "；";
        //            }
        //        }
        //        finally
        //        {
        //            reader11.Close();
        //        }
        //    }
        //    str = "select a.OrganSchoolId, a.UserId, a.Schoolbh, a.Schoolname, a.Organbh, b.OrganName FROM  OrganSchool AS a INNER JOIN  OrganUser AS b ON a.Organbh = b.LoginId where a.schoolbh='" + str3 + "'";
        //    using (SqlDataReader reader12 = SqlHelper.ExecuteReader(SqlHelper.ConnHealth, CommandType.Text, str, new SqlParameter[0]))
        //    {
        //        try
        //        {
        //            while (reader12.Read())
        //            {
        //                this.litSchoolname.Text = this.litSchoolname.Text + "(" + reader12["OrganName"] as string + ")";
        //            }
        //        }
        //        finally
        //        {
        //            reader12.Close();
        //        }
        //    }
        //}

 

 

    }
    //public class SelfItem
    //{
    //    public string Name { get; set; }
    //    public string Value { get; set; }
    //}
}